www.gusucode.com > ROCKOA PHP协同办公OA办公系统 v2.0PHP源码程序 > ROCKOA PHP协同办公OA办公系统 v2.0/rockoa_v2.0/rockoa_v2.0/webrock/humanres/kaoqin/ext_kaoqin_dkjlscript.js
var form; function opendown(){ var url = js.getajaxurl('downexcel','where','public',{fields:escape('姓名,指纹号,时间(用[]扩起来)'),title:escape('打卡记录格式'),content:escape('管理员,1,[2015-01-18 08:50:50]')}); js.open(url); } function importdown(){ uploadwindows.imports({ url:js.getajaxurl('import','kaoqin','humanres'), callback:function(){ rock[index].storereload(); } }); } var panel={ xtype:'rockgrid',url:js.getajaxurl('dkjl', 'kaoqin', 'person'), tablename:'kq_dkjl',searchtools:true,checkcolumns:true,exceltitle:'打卡记录', tbarcenter:['日期从',{ xtype:'datefield',editable:false,format:'Y-m-d',width:100,id:'startdt_'+rand+'' },'至',{ xtype:'datefield',editable:false,format:'Y-m-d',width:100,id:'enddt_'+rand+'' }], outsearch:function(){ var s = '',s3, s1= getcmp('startdt_'+rand+'').getRawValue(), s2= getcmp('enddt_'+rand+'').getRawValue(); if(!isempt(s1))s="[A][K]a.`checktime`[K]>=[K]'"+s1+" 00:00:00'"; if(!isempt(s2))s+="[K][A][K]a.`checktime`[K]<=[K]'"+s2+" 23:59:59'"; return s; }, tbar:['-',{ text:'导入',icon:gicons('page_excel'),tooltip:'必须按照导入文件格式写',menu:[{ text:'下载导入文件格式',icon:gicons('arrow_down'),handler:opendown },'-',{ text:'导入Excel文件',handler:importdown }] },'-','打卡记录导入格式需要定制开发','->',{ text:'删除',icon:gicons('delete'),handler:function(){ rock[index].del(false,true); } }], columns:[{ xtype: 'rownumberer', width: 40 },{ text:'部门',dataIndex:'deptname',width:260,search:true,qz:'b.' },{ text:'姓名',align:'center',dataIndex:'name',width:120,search:true,qz:'b.' },{ text:'指纹号',align:'center',dataIndex:'finge',width:80,search:true,qz:'a.' },{ text:'时间',align:'center',dataIndex:'checktime',width:230,search:true },{ text:'星期',dataIndex:'cnweek',width:100 },{ text:'ID',align:'center',dataIndex:'id',width:60 }] } return { panel:panel };